11 - Chart Object - Scatter Plot 11
Below is a picture of our completed Scatter Plot .
The first thing we need to do is select a Scatter Plot from the Charts onto our sheet.
Next we can add our dimension and measures and apply some formatting
Now that we just need to add the measure that will determine the size of the plots
We can adjust the bubble size in the properties panel under the ‘Presentation’ tab
After we get both target lines onto our chart we get the below product
Below is the expression for our color format. We have included a text file. You can use this to copy and paste the expression.
Here is how it works in the graph
Here is the working finish product